User name:
Password:
 

 

Copyright © 2006.
cisco-certificatiom.co.uk
All Rights Reserved
Excel 2000 MOS Expert Series: Analyzing Data and Using PivotTables
Product Code: e2ke06 Time: 3.0 hour(s) CEUs: Available

Summary:

This course shows how to use data analysis tools such as Goal Seek, Solver, and Scenarios, and PivotTables and PivotCharts.

Objectives:

  • Use Goal Seek to backsolve from a solution to its values
  • Use Solver
  • Work with scenarios
  • Use PivotTables for data analysis
  • Use the PivotTable AutoFormat feature
  • Create PivotChart reports
  • Create an interactive PivotTable for the Web
  • Add fields to a PivotTable using the Web browser


Topics:

  • Using Goal Seek
  • Using Solver
  • Working with Scenarios
  • Using Data Analysis and PivotTables
  • Using PivotTables and PivotCharts
  • Using a PivotTable with the Web

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Copyright � 2006 Webteks. All rights reserved.